namespace SPI.AgentServer.Services.Security;

public interface ISqlParser
{
    SqlParseResult Parse(string sql);
}

public class SqlParseResult
{
    public bool Success { get; set; }
    public SqlStatementType StatementType { get; set; }
    public List<string> Tables { get; set; } = new();
    public List<string> Columns { get; set; } = new();
    public List<string> Operations { get; set; } = new();
    public string? Error { get; set; }
}

public enum SqlStatementType
{
    Select,
    Insert,
    Update,
    Delete,
    Create,
    Alter,
    Drop,
    Truncate,
    Other
}
